home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Night Owl 6
/
Night Owl's Shareware - PDSI-006 - Night Owl Corp (1990).iso
/
016a
/
bingo2.zip
/
BINGO.SC
< prev
next >
Wrap
Text File
|
1991-09-16
|
2KB
|
76 lines
;******************************************************************************
;* BINGO.SC The sole purpose of this program is to enable quick comparisons *
;* on screen of the STRUCTURES of TWO different tables. The code in this *
;* particular script is 'HEAVILY BORROWED' from another file in the BORDB *
;* libraries called PRTSTR.ARC (Print Structure): My sincere thanks to the *
;* author for some great ideas to solve a practical problem. Dickford Cohn *
;******************************************************************************
PROC TablComp()
CLEAR
CLEARALL
Release VARS ALL
; ACCEPT the name of the FIRST table
BEEP SLEEP 100 BEEP
STYLE ATTRIBUTE 140
msay = "▒ Select 1st Table Structure ▒"
msaycol =INT((80-LEN(msay))/2)
@ 10, msaycol ?? msay
SHOWTABLES
DIRECTORY()
"Highlight the FIRST TABLE TO COMPARE, then Press <Enter> ─┘"
TO mtable1
msay1 = UPPER(mtable1)+".DB"
msaycol =INT((80-LEN(msay1))/2)
@ 11, msaycol ?? msay1
IF mtable1 = "Esc"
THEN MENU RETURN
ENDIF
; tools/info/structure/enter table name
MENU {Tools} {Info} {Structure}
TYPEIN mtable1
ENTER
DO_IT!
; ADD the STRUCT TABLE to the FIRST QUERY TABLE
EMPTY "Bingo1"
ADD "STRUCT" "Bingo1"
CLEAR
; ACCEPT the name of the SECOND table
BEEP SLEEP 100 BEEP
STYLE ATTRIBUTE 140
msay2 = "▒ Select 2nd Table Structure ▒"
msaycol =INT((80-LEN(msay))/2)
@ 10, msaycol ?? msay2
SHOWTABLES
DIRECTORY()
"Highlight the SECOND TABLE TO COMPARE, then Press <Enter> ─┘"
TO mtable2
msay2 = UPPER(mtable2)+".DB"
msaycol =INT((80-LEN(msay2))/2)
@ 11, msaycol ?? msay2
IF mtable2 = "Esc"
THEN MENU RETURN
ENDIF
; tools/info/structure/enter table name
MENU {Tools} {Info} {Structure}
TYPEIN mtable2
ENTER
DO_IT!
; ADD the STRUCT table to the SECOND QUERY TABLE
EMPTY "Bingo2"
ADD "STRUCT" "Bingo2"
; SAVE the Variables
SAVEVARS ALL
;On to the FUN!!! --- BINGO1.SC uses an EXAMPLE QUERY to INSERT the contents of
;BINGO1.DB into the BINGO (Master) TABLE.
PLAY "Bingo1"
ENDPROC
TablComp()